<%--
    Document   : temp
    Created on : Oct 4, 2012, 4:10:02 PM
    Author     : MinhThang
--%>

<%@page import="org.apt.connectDB.MyConnect"%>
<%@page import="java.sql.ResultSet"%>
<%@page import="java.sql.PreparedStatement"%>
<%@page import="java.sql.Connection"%>
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
    "http://www.w3.org/TR/html4/loose.dtd">

<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <title>JSP Page</title>
        <link href="style/css/transdmin.css" rel="stylesheet" type="text/css" media="screen" />
        <link href="../style/style.css" rel="stylesheet" type="text/css" media="screen" />
        <!--[if IE 6]><link rel="stylesheet" type="text/css" media="screen" href="style/css/ie6.css" /><![endif]-->
        <!--[if IE 7]><link rel="stylesheet" type="text/css" media="screen" href="style/css/ie7.css" /><![endif]-->

        <!-- JavaScripts-->
        <script type="text/javascript" src="style/js/jquery.js"></script>
        <script type="text/javascript" src="style/js/jNice.js"></script>
    </head>
    <body>
        <%
                    if (session.getAttribute("AdminUser") == null || session.getAttribute("AdminUser").toString() == "") {
                        response.sendRedirect("/Admin/adminlogin.jsp");
                    }
        %>
        <div id="wrapper">
            <h1><a href="#"><span>Admin Paper Presentation</span></a></h1>
            <div><%@include file="Template/header.jsp" %></div>
            <div id="containerHolder">
                <div id="sidebar">
                    <ul class="sideNav">
                        <li class="limenu"><a href="#"  >Menu 1</a></li>
                        <li class="limenu"><a href="#">Menu 2</a></li>
                        <li class="limenu"><a href="#">Menu 3</a></li>
                        <li class="limenu"><a href="#">Menu 4</a></li>
                        <li class="limenu"><a href="create_new_group_payment.jsp" class="active">Style payment</a></li>
                        <li class="limenu"><a href="#">Menu 6</a></li>
                    </ul>
                    <!-- // .sideNav -->
                </div>
                <h2><a href="#">Payment >></a> <a href="#" class="active">Create style payment</a></h2>
                <div id="main">

                    <table border="1" style="width: 95%">

                        <tr>
                            <td><h3>List style</h3></td>
                        </tr>
                        <tr>
                            <td>
                                <table >
                                    <tr>
                                        <td><b>Name Style </b></td>
                                        <td></td>
                                    </tr>
                                    <%
                                                //display data
                                                Connection conn = null;
                                                PreparedStatement ps = null;
                                                ResultSet rs = null;
                                                String sql = "SELECT * FROM GroupPayment";
                                                try {
                                                    conn = MyConnect.getConnection();
                                                            ps = conn.prepareCall(sql);
                                                            rs = ps.executeQuery();
                                                            while (rs.next()) {%>
                                    <tr>
                                        <td><%=rs.getString("Style").toString()%></td>
                                        <td><a href="update_group_payment.jsp?ID=<%=rs.getString("ID").toString()%>">Edit</a>  <a href="#">Delete</a></td>
                                    </tr>
                                    <% }
                                                } catch (Exception e) {
                                                    e.printStackTrace();
                                                }
                                    %>
                                </table>

                            </td>
                        </tr>
                        <tr>
                            <td><h3>Create New</h3></td>
                        </tr>
                        <tr>
                            <td>
                                <form action="createstyle.do" method="post" name="form_2">
                                    <table>
                                        <tr>
                                            <td width="250px;"><input type="text" name="txtNameGroup" value="" style="width: 200px;" /></td>
                                            <td></td>
                                        </tr>
                                        <tr>
                                            <td><input id="pagestatus" type="submit" value="Create" /></td>
                                            <td></td>
                                        </tr>
                                    </table>
                                </form>
                            </td>
                        </tr>
                    </table>
                </div>
                <!-- // #main -->
                <div class="clear"></div>
            </div>
        </div>
    </body>
</html>
